Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TimePunchApprovalID (PK) | A unique system assigned identifier for the after the fact confirmation that the TimePunch entry is valid. | ID_APVL_TPNCH | Identity | integer | |
ReasonCode (FK) | A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
TimePunchEntryID (FK) | A unique system-assigned identifier for the particular TimePunchEntry that is being approved. | ID_ENR_TPNCH | Identity | integer | WorkerTimePunchEntry(DO_TPNCH_WKR) |
OperatorID (FK) | A unique, automatically assigned number used to identify a workstation OPERATOR. | ID_OPR | Identity | integer | Operator(PA_OPR) |
ApprovalDateTime | The date and time the TimePunchApproval was made. | DC_APVL | AuditDateTime | datetime | |